package cn.lx.mapper;


import cn.lx.pojo.TlIndex;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author lixin
 */
@Mapper
public interface IndexMapper {
    @Select(" select id,company_name from tl_index where  company_name like CONCAT(#{company_name,jdbcType=VARCHAR},'%' ) limit 0,10")
    List<TlIndex> search(String word);

    @Select(" select id,company_name from tl_index order by company_name desc limit 0,300")
    List<TlIndex> listAll();
}
